delete from businessSetting where uidSetting >= 123 and uidSetting <= 132;

INSERT INTO businessSetting (uidBusiness, uidSetting, settingValue)
SELECT 1,123,'0' UNION ALL
SELECT 1,124,'0' UNION ALL
SELECT 1,125,'0' UNION ALL
SELECT 1,126,'0' UNION ALL
SELECT 1,127,'0' UNION ALL
SELECT 1,128,'0' UNION ALL
SELECT 1,129,'0' UNION ALL
SELECT 1,130,'0' UNION ALL
SELECT 1,131,'0' UNION ALL
SELECT 1,132,'0';

UPDATE businessSetting
   SET settingValue = '1'
 WHERE uidSetting IN (124,125,126,127,128,129,130,131)
   AND NOT EXISTS (SELECT NULL
                     FROM account 
                    WHERE accountID = 'HMRC-VAT'
                       OR uidAccountSubCat IN (11,12));

-- Update the schema
update systemSetting
   set settingValue = 37
 where uidSetting = 5;